
	
/****** Object:  Stored Procedure [sapro].SanPhamInsert    Script Date: Thursday, March 18, 2010 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spSanPhamInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [sapro].[spSanPhamInsert]
GO

			
	
	

/******************************************************************************
**		File: 
**		Name: [sapro].spSanPhamInsert
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 3/18/2010 5:04:46 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE [sapro].spSanPhamInsert
	@MaSanPham nvarchar(50),
	@TenSanPham nvarchar(150),
	@SoDiem int,
	@NoiDung nvarchar(255),
	@ChiTiet nvarchar,
	@DanhMuc int,
	@AnhDaiDien nvarchar(150),
	@AnhLon nvarchar(150)
AS

INSERT INTO [sapro].[SanPham] 
(
	[MaSanPham],
	[TenSanPham],
	[SoDiem],
	[NoiDung],
	[ChiTiet],
	[DanhMuc],
	[AnhDaiDien],
	[AnhLon]
) 
VALUES 
(
	@MaSanPham,
	@TenSanPham,
	@SoDiem,
	@NoiDung,
	@ChiTiet,
	@DanhMuc,
	@AnhDaiDien,
	@AnhLon
)


GO
	

